﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Web.UI;
using Pension.DAL;


namespace Pension.BLL
{
    public class SampleClass : ClassServices
    {
        private OracleDBManager objDb = null;
        private DbParameter objParam = null;

        public SampleClass()
        {
        }

        #region Select Data

        public DataSet GetAllScore(string Parametor1, string Parametor2)
        {
            DataSet ds = new DataSet();
            objDb = new OracleDBManager();
            objParam = new DbParameter();
            objParam.CreateParameters(3);
            objParam.AddParameter(0, "P_APPLICATION_CODE", Parametor1);
            objParam.AddParameter(1, "P_ENTITY_CODE", Parametor2);
            objParam.AddParameter(2, "P_RS", ParameterDirection.Output, ParameterType.DbTable);
            ds = objDb.ExecuteQuery(objParam, QAGetAllScore);
            return ds;
        }   

        #endregion

        #region Insert Data

        #endregion

        #region Update Data

        #endregion

        #region Delete Data

        #endregion
    }
}
